create or replace procedure SP_BatInsertFile(
p_FILE_NAME varchar2,
p_FILE_EXT number,
p_FILE_ABST varchar2,
p_FILE_AUTHOR varchar2,
p_KEYW varchar2,
p_FILE_CRT_DATE varchar2,
p_FILE_VERSION varchar2,
p_DEST_OBJ number,
p_BIZ_OBJ number,
p_SECRET_LVL varchar2,
p_LANG_TYPE varchar2,
p_FILE_TYPE varchar2,
p_SAVE_PATH varchar2,
p_TEAM_ID number,
p_USER_ID varchar2
) is

begin

  INSERT INTO TB_XMK_FILE (FILE_NAME ,FILE_EXT ,FILE_ABST ,FILE_AUTHOR ,KEYW ,FILE_CRT_DATE ,
FILE_VERSION ,DEST_OBJ ,BIZ_OBJ ,SECRET_LVL ,LANG_TYPE ,FILE_TYPE ,SAVE_PATH ,TEAM_ID ,USER_ID,STATUS) values (
p_FILE_NAME ,p_FILE_EXT ,p_FILE_ABST ,p_FILE_AUTHOR ,p_KEYW ,
to_date(p_FILE_CRT_DATE,'yyyy-mm-dd hh24:mi:ss') ,p_FILE_VERSION ,p_DEST_OBJ ,p_BIZ_OBJ ,p_SECRET_LVL ,p_LANG_TYPE 
,p_FILE_TYPE ,p_SAVE_PATH
,p_TEAM_ID
,p_USER_ID,1);
end SP_BatInsertFile;
